1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class LoaiThucDonMod
15 {
16 protected string IdLoaiThucDon { get; set; }
17 protected string TenLoaiThucDon { get; set; }
18 protected string DienGiai { get; set; }
19 protected string TrangThai { get; set; }
20 public LoaiThucDonMod(string _IdLoaiThucDon)
21 {
22 IdLoaiThucDon = _IdLoaiThucDon;
23 }
24 public LoaiThucDonMod()
25 { }
26 public LoaiThucDonMod(string _idloaithucdon, string _tenloaithucdon, string _diengiai, string _trangthai)
27 {
28 this.IdLoaiThucDon = _idloaithucdon;
29 this.TenLoaiThucDon = _tenloaithucdon;
30 this.DienGiai = _diengiai;
31 this.TrangThai = _trangthai;
32 }
33 public int InsertLoaiThucDon()
34 {
35 int i = 0;
36 string[] paras = new string[4] { "@IdLoaiThucDon", "@TenLoaiThucDon", "@DienGiai", "@TrangThai"};
37 object[] values = new object[4] { IdLoaiThucDon,TenLoaiThucDon,DienGiai,TrangThai };
38 i = Models.connection.Excute_Sql("spInsertLoaiThucDon", CommandType.StoredProcedure, paras, values);
39 return i;
40 }
41 public int UpdateLoaiThucDon()
42 {
43 int i = 0;
44 string[] paras = new string[4] { "@IdLoaiThucDon", "@TenLoaiThucDon", "@DienGiai", "@TrangThai" };
45 object[] values = new object[4] { IdLoaiThucDon, TenLoaiThucDon, DienGiai, TrangThai };
46 i = Models.connection.Excute_Sql("spUpdateLoaiThucDon", CommandType.StoredProcedure, paras, values);
47 return i;
48 }
49 public int DeleteLoaiThucDon()
50 {
51 int i = 0;
52 string[] paras = new string[1] { "@IdLoaiThucDon" };
53 object[] values = new object[1] { IdLoaiThucDon };
54 i = Models.connection.Excute_Sql("spDeleteLoaiThucDon", CommandType.StoredProcedure, paras, values);
55 return i;
56 }
57 public static DataSet FillDataSetLoaiThucDon()
58 {
59 return Models.connection.FillDataSet("spgetLoaiThucDon", CommandType.StoredProcedure);
60 }
61 public static DataSet FillDataSet_getTenLoaiThucDon()
62 {
63 return Models.connection.FillDataSet("spgetTenLoaiThucDon", CommandType.StoredProcedure);
64 }
65 public DataSet FillDataSet_getLoaiThucDonByIdLoaiThucDon()
66 {
67 DataSet ds = new DataSet();
68 string[] paras = new string[1] { "@IdLoaiThucDon" };
69 object[] values = new object[1] { IdLoaiThucDon };
70 ds = Models.connection.FillDataSet("spgetLoaiThucDonByIdLoaiThucDon", CommandType.StoredProcedure, paras, values);
71 return ds;
72 }
73
74 }
75 }